package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:32
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysMessageReadStatusDAOQueryBean extends BaseQueryBean {
    public SysMessageReadStatusDAOQueryBean() {
        super();
    }

    public SysMessageReadStatusDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysMessageReadStatusDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.Id, "id");
        }
    }

    public void addSysMessageIdSelectProperty() {
        addSysMessageIdSelectProperty("sysMessageId");
    }

    public void addSysMessageIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageId, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageId,
                "sysMessageId");
        }
    }

    public void addReceiverIdSelectProperty() {
        addReceiverIdSelectProperty("receiverId");
    }

    public void addReceiverIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.ReceiverId, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.ReceiverId, "receiverId");
        }
    }

    public void addReadTimeSelectProperty() {
        addReadTimeSelectProperty("readTime");
    }

    public void addReadTimeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.ReadTime, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.ReadTime, "readTime");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.Status, "status");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.Remarks, "remarks");
        }
    }

    public void addIsDropedSelectProperty() {
        addIsDropedSelectProperty("isDroped");
    }

    public void addIsDropedSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.IsDroped, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.IsDroped, "isDroped");
        }
    }

    public void addReceiverNameSelectProperty() {
        addReceiverNameSelectProperty("receiverName");
    }

    public void addReceiverNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.ReceiverName, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.ReceiverName,
                "receiverName");
        }
    }

    public void addReceiverAccountSelectProperty() {
        addReceiverAccountSelectProperty("receiverAccount");
    }

    public void addReceiverAccountSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.ReceiverAccount, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.ReceiverAccount,
                "receiverAccount");
        }
    }

    public void addSysMessageTitleSelectProperty() {
        addSysMessageTitleSelectProperty("sysMessageTitle");
    }

    public void addSysMessageTitleSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageTitle, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageTitle,
                "sysMessageTitle");
        }
    }

    public void addSysMessagePrioritySelectProperty() {
        addSysMessagePrioritySelectProperty("sysMessagePriority");
    }

    public void addSysMessagePrioritySelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessagePriority,
                aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessagePriority,
                "sysMessagePriority");
        }
    }

    public void addSysMessageSendTimeSelectProperty() {
        addSysMessageSendTimeSelectProperty("sysMessageSendTime");
    }

    public void addSysMessageSendTimeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSendTime,
                aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSendTime,
                "sysMessageSendTime");
        }
    }

    public void addSysMessageStatusSelectProperty() {
        addSysMessageStatusSelectProperty("sysMessageStatus");
    }

    public void addSysMessageStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageStatus, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageStatus,
                "sysMessageStatus");
        }
    }

    public void addSysMessageContentSelectProperty() {
        addSysMessageContentSelectProperty("sysMessageContent");
    }

    public void addSysMessageContentSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageContent, aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageContent,
                "sysMessageContent");
        }
    }

    public void addSysMessageSenderNameSelectProperty() {
        addSysMessageSenderNameSelectProperty("sysMessageSenderName");
    }

    public void addSysMessageSenderNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSenderName,
                aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSenderName,
                "sysMessageSenderName");
        }
    }

    public void addSysMessageSenderAccountSelectProperty() {
        addSysMessageSenderAccountSelectProperty("sysMessageSenderAccount");
    }

    public void addSysMessageSenderAccountSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSenderAccount,
                aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSenderAccount,
                "sysMessageSenderAccount");
        }
    }

    public void addSysMessageSenderIdSelectProperty() {
        addSysMessageSenderIdSelectProperty("sysMessageSenderId");
    }

    public void addSysMessageSenderIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSenderId,
                aAlias);
        } else {
            addSelectProperty(ISysMessageReadStatusDAO.SysMessageSenderId,
                "sysMessageSenderId");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addSysMessageIdSelectProperty();

        addReceiverIdSelectProperty();

        addReadTimeSelectProperty();

        addStatusSelectProperty();

        addRemarksSelectProperty();

        addIsDropedSelectProperty();

        addReceiverNameSelectProperty();

        addReceiverAccountSelectProperty();

        addSysMessageTitleSelectProperty();

        addSysMessagePrioritySelectProperty();

        addSysMessageSendTimeSelectProperty();

        addSysMessageStatusSelectProperty();

        addSysMessageContentSelectProperty();

        addSysMessageSenderNameSelectProperty();

        addSysMessageSenderAccountSelectProperty();

        addSysMessageSenderIdSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysMessageReadStatusDAOQueryBean> {
        protected Criteria(SysMessageReadStatusDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysMessageReadStatusDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.Id + " is not null AND " +
                ISysMessageReadStatusDAO.Id + " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.Id + " is null OR " +
                ISysMessageReadStatusDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " is null OR " +
                ISysMessageReadStatusDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Id + " not in", values,
                    "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.Id + " not in", values,
                    "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Id + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andSysMessageIdIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " is null");

            return this;
        }

        public Criteria andSysMessageIdIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId +
                " is not null");

            return this;
        }

        public Criteria andSysMessageIdIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId +
                " is not null AND " + ISysMessageReadStatusDAO.SysMessageId +
                " <> ''");

            return this;
        }

        public Criteria andSysMessageIdIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageId +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageId +
                " = '')");

            return this;
        }

        public Criteria andSysMessageIdEqualTo(long value) {
            return andSysMessageIdEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageIdEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " = ", value,
                "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdNotEqualTo(long value) {
            return andSysMessageIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " <>", value,
                "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdNotEqualToOrIsNull(long value) {
            return andSysMessageIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andSysMessageIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageId + " <>",
                value, "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdGreaterThan(long value) {
            return andSysMessageIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andSysMessageIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " >", value,
                "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdGreaterThanOrEqualTo(long value) {
            return andSysMessageIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageIdGreaterThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " >=", value,
                "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdLessThan(long value) {
            return andSysMessageIdLessThan(Long.valueOf(value));
        }

        public Criteria andSysMessageIdLessThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " <", value,
                "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdLessThanOrEqualTo(long value) {
            return andSysMessageIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " <=", value,
                "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdIn(long[] values) {
            if (values.length == 1) {
                return andSysMessageIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageId + " in",
                    values, "sysMessageId");

                return this;
            }
        }

        public Criteria andSysMessageIdNotIn(long[] values) {
            if (values.length == 1) {
                return andSysMessageIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageId + " not in",
                    values, "sysMessageId");

                return this;
            }
        }

        public Criteria andSysMessageIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andSysMessageIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageId + " in",
                    values, "sysMessageId");

                return this;
            }
        }

        public Criteria andSysMessageIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andSysMessageIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageId + " not in",
                    values, "sysMessageId");

                return this;
            }
        }

        public Criteria andSysMessageIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andSysMessageIdEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageId + " in",
                    Arrays.asList(values), "sysMessageId");

                return this;
            }
        }

        public Criteria andSysMessageIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andSysMessageIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageId + " not in",
                    Arrays.asList(values), "sysMessageId");

                return this;
            }
        }

        public Criteria andSysMessageIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageIdBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " between",
                value1, value2, "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId + " between",
                value1, value2, "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdNotBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId +
                " not between", value1, value2, "sysMessageId");

            return this;
        }

        public Criteria andSysMessageIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageId +
                " not between", value1, value2, "sysMessageId");

            return this;
        }

        public Criteria andReceiverIdIsNull() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " is null");

            return this;
        }

        public Criteria andReceiverIdIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " is not null");

            return this;
        }

        public Criteria andReceiverIdIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId +
                " is not null AND " + ISysMessageReadStatusDAO.ReceiverId +
                " <> ''");

            return this;
        }

        public Criteria andReceiverIdIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.ReceiverId +
                " is null OR " + ISysMessageReadStatusDAO.ReceiverId +
                " = '')");

            return this;
        }

        public Criteria andReceiverIdEqualTo(long value) {
            return andReceiverIdEqualTo(Long.valueOf(value));
        }

        public Criteria andReceiverIdEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " = ", value,
                "receiverId");

            return this;
        }

        public Criteria andReceiverIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdNotEqualTo(long value) {
            return andReceiverIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andReceiverIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " <>", value,
                "receiverId");

            return this;
        }

        public Criteria andReceiverIdNotEqualToOrIsNull(long value) {
            return andReceiverIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andReceiverIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " is null OR " +
                ISysMessageReadStatusDAO.ReceiverId + " <>", value, "receiverId");

            return this;
        }

        public Criteria andReceiverIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdGreaterThan(long value) {
            return andReceiverIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andReceiverIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " >", value,
                "receiverId");

            return this;
        }

        public Criteria andReceiverIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdGreaterThanOrEqualTo(long value) {
            return andReceiverIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andReceiverIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " >=", value,
                "receiverId");

            return this;
        }

        public Criteria andReceiverIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdLessThan(long value) {
            return andReceiverIdLessThan(Long.valueOf(value));
        }

        public Criteria andReceiverIdLessThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " <", value,
                "receiverId");

            return this;
        }

        public Criteria andReceiverIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdLessThanOrEqualTo(long value) {
            return andReceiverIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andReceiverIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " <=", value,
                "receiverId");

            return this;
        }

        public Criteria andReceiverIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdIn(long[] values) {
            if (values.length == 1) {
                return andReceiverIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverId + " in",
                    values, "receiverId");

                return this;
            }
        }

        public Criteria andReceiverIdNotIn(long[] values) {
            if (values.length == 1) {
                return andReceiverIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverId + " not in",
                    values, "receiverId");

                return this;
            }
        }

        public Criteria andReceiverIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andReceiverIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverId + " in",
                    values, "receiverId");

                return this;
            }
        }

        public Criteria andReceiverIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andReceiverIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverId + " not in",
                    values, "receiverId");

                return this;
            }
        }

        public Criteria andReceiverIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andReceiverIdEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverId + " in",
                    Arrays.asList(values), "receiverId");

                return this;
            }
        }

        public Criteria andReceiverIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andReceiverIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverId + " not in",
                    Arrays.asList(values), "receiverId");

                return this;
            }
        }

        public Criteria andReceiverIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverIdBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " between",
                value1, value2, "receiverId");

            return this;
        }

        public Criteria andReceiverIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " between",
                value1, value2, "receiverId");

            return this;
        }

        public Criteria andReceiverIdNotBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " not between",
                value1, value2, "receiverId");

            return this;
        }

        public Criteria andReceiverIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverId + " not between",
                value1, value2, "receiverId");

            return this;
        }

        public Criteria andReadTimeIsNull() {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " is null");

            return this;
        }

        public Criteria andReadTimeIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " is not null");

            return this;
        }

        public Criteria andReadTimeIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.ReadTime +
                " is not null AND " + ISysMessageReadStatusDAO.ReadTime +
                " <> ''");

            return this;
        }

        public Criteria andReadTimeIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.ReadTime +
                " is null OR " + ISysMessageReadStatusDAO.ReadTime + " = '')");

            return this;
        }

        public Criteria andReadTimeEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime + " = ",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReadTime);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReadTimeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeNotEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime + " <>",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeNotEqualToOrIsNull(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                " is null OR " + ISysMessageReadStatusDAO.ReadTime + " <>",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReadTime);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReadTimeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeGreaterThan(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime + " >",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReadTime);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReadTimeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeGreaterThanOrEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime + " >=",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReadTime);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReadTimeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeLessThan(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime + " <",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReadTime);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReadTimeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeLessThanOrEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime + " <=",
                value, "readTime");

            return this;
        }

        public Criteria andReadTimeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReadTime);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReadTimeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andReadTimeEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                    " in", values, "readTime");

                return this;
            }
        }

        public Criteria andReadTimeNotIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andReadTimeNotEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                    " not in", values, "readTime");

                return this;
            }
        }

        public Criteria andReadTimeIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andReadTimeEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                    " in", Arrays.asList(values), "readTime");

                return this;
            }
        }

        public Criteria andReadTimeNotIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andReadTimeNotEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                    " not in", Arrays.asList(values), "readTime");

                return this;
            }
        }

        public Criteria andReadTimeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReadTime + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReadTimeBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                " between", value1, value2, "readTime");

            return this;
        }

        public Criteria andReadTimeNotBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.ReadTime +
                " not between", value1, value2, "readTime");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysMessageReadStatusDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.Status + " is not null AND " +
                ISysMessageReadStatusDAO.Status + " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.Status +
                " is null OR " + ISysMessageReadStatusDAO.Status + " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " = ", value,
                "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " = ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " <>", value,
                "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " is null OR " +
                ISysMessageReadStatusDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " >", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " > ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " >=", value,
                "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " <", value, "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " < ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Status + " <=", value,
                "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.Status + " like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.Status + " not like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.Status + " in", values,
                    "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.Status + " not in",
                    values, "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Status + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.Status + " between", value1,
                value2, "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.Status + " not between",
                value1, value2, "status");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.Remarks +
                " is not null AND " + ISysMessageReadStatusDAO.Remarks +
                " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.Remarks +
                " is null OR " + ISysMessageReadStatusDAO.Remarks + " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " = ", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " <>", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " is null OR " +
                ISysMessageReadStatusDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " >", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " >=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " <", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " <=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.Remarks + " like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.Remarks + " in", values,
                    "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.Remarks + " not in",
                    values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " between", value1,
                value2, "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.Remarks + " not between",
                value1, value2, "remarks");

            return this;
        }

        public Criteria andIsDropedIsNull() {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " is null");

            return this;
        }

        public Criteria andIsDropedIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " is not null");

            return this;
        }

        public Criteria andIsDropedIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.IsDroped +
                " is not null AND " + ISysMessageReadStatusDAO.IsDroped +
                " <> ''");

            return this;
        }

        public Criteria andIsDropedIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.IsDroped +
                " is null OR " + ISysMessageReadStatusDAO.IsDroped + " = '')");

            return this;
        }

        public Criteria andIsDropedEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " = ", value,
                "isDroped");

            return this;
        }

        public Criteria andIsDropedEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.IsDroped);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIsDropedEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " <>", value,
                "isDroped");

            return this;
        }

        public Criteria andIsDropedNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " is null OR " +
                ISysMessageReadStatusDAO.IsDroped + " <>", value, "isDroped");

            return this;
        }

        public Criteria andIsDropedNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.IsDroped);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIsDropedNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " >", value,
                "isDroped");

            return this;
        }

        public Criteria andIsDropedGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.IsDroped);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIsDropedGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " >=", value,
                "isDroped");

            return this;
        }

        public Criteria andIsDropedGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.IsDroped);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIsDropedGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " <", value,
                "isDroped");

            return this;
        }

        public Criteria andIsDropedLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.IsDroped);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIsDropedLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " <=", value,
                "isDroped");

            return this;
        }

        public Criteria andIsDropedLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.IsDroped);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIsDropedLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " like",
                buffer.toString(), "isDroped");

            return this;
        }

        public Criteria andIsDropedNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " not like",
                buffer.toString(), "isDroped");

            return this;
        }

        public Criteria andIsDropedIn(List<String> values) {
            if (values.size() == 1) {
                return andIsDropedEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.IsDroped + " in", values,
                    "isDroped");

                return this;
            }
        }

        public Criteria andIsDropedNotIn(List<String> values) {
            if (values.size() == 1) {
                return andIsDropedNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.IsDroped + " not in",
                    values, "isDroped");

                return this;
            }
        }

        public Criteria andIsDropedIn(String[] values) {
            if (values.length == 1) {
                return andIsDropedEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.IsDroped + " in",
                    Arrays.asList(values), "isDroped");

                return this;
            }
        }

        public Criteria andIsDropedNotIn(String[] values) {
            if (values.length == 1) {
                return andIsDropedNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.IsDroped + " not in",
                    Arrays.asList(values), "isDroped");

                return this;
            }
        }

        public Criteria andIsDropedIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIsDropedBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " between",
                value1, value2, "isDroped");

            return this;
        }

        public Criteria andIsDropedNotBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.IsDroped + " not between",
                value1, value2, "isDroped");

            return this;
        }

        public Criteria andReceiverNameIsNull() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " is null");

            return this;
        }

        public Criteria andReceiverNameIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName +
                " is not null");

            return this;
        }

        public Criteria andReceiverNameIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName +
                " is not null AND " + ISysMessageReadStatusDAO.ReceiverName +
                " <> ''");

            return this;
        }

        public Criteria andReceiverNameIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.ReceiverName +
                " is null OR " + ISysMessageReadStatusDAO.ReceiverName +
                " = '')");

            return this;
        }

        public Criteria andReceiverNameEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " = ", value,
                "receiverName");

            return this;
        }

        public Criteria andReceiverNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " <>", value,
                "receiverName");

            return this;
        }

        public Criteria andReceiverNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName +
                " is null OR " + ISysMessageReadStatusDAO.ReceiverName + " <>",
                value, "receiverName");

            return this;
        }

        public Criteria andReceiverNameNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " >", value,
                "receiverName");

            return this;
        }

        public Criteria andReceiverNameGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " >=", value,
                "receiverName");

            return this;
        }

        public Criteria andReceiverNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " <", value,
                "receiverName");

            return this;
        }

        public Criteria andReceiverNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " <=", value,
                "receiverName");

            return this;
        }

        public Criteria andReceiverNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " like",
                buffer.toString(), "receiverName");

            return this;
        }

        public Criteria andReceiverNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " not like",
                buffer.toString(), "receiverName");

            return this;
        }

        public Criteria andReceiverNameIn(List<String> values) {
            if (values.size() == 1) {
                return andReceiverNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverName + " in",
                    values, "receiverName");

                return this;
            }
        }

        public Criteria andReceiverNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andReceiverNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverName + " not in",
                    values, "receiverName");

                return this;
            }
        }

        public Criteria andReceiverNameIn(String[] values) {
            if (values.length == 1) {
                return andReceiverNameEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverName + " in",
                    Arrays.asList(values), "receiverName");

                return this;
            }
        }

        public Criteria andReceiverNameNotIn(String[] values) {
            if (values.length == 1) {
                return andReceiverNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverName + " not in",
                    Arrays.asList(values), "receiverName");

                return this;
            }
        }

        public Criteria andReceiverNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverNameBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName + " between",
                value1, value2, "receiverName");

            return this;
        }

        public Criteria andReceiverNameNotBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverName +
                " not between", value1, value2, "receiverName");

            return this;
        }

        public Criteria andReceiverAccountIsNull() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " is null");

            return this;
        }

        public Criteria andReceiverAccountIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                " is not null");

            return this;
        }

        public Criteria andReceiverAccountIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                " is not null AND " + ISysMessageReadStatusDAO.ReceiverAccount +
                " <> ''");

            return this;
        }

        public Criteria andReceiverAccountIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.ReceiverAccount +
                " is null OR " + ISysMessageReadStatusDAO.ReceiverAccount +
                " = '')");

            return this;
        }

        public Criteria andReceiverAccountEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " = ",
                value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverAccount);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverAccountEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " <>",
                value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                " is null OR " + ISysMessageReadStatusDAO.ReceiverAccount +
                " <>", value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverAccount);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverAccountNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " >",
                value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverAccount);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverAccountGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " >=",
                value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverAccount);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverAccountGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " <",
                value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverAccount);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverAccountLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " <=",
                value, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.ReceiverAccount);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andReceiverAccountLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " like",
                buffer.toString(), "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                " not like", buffer.toString(), "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountIn(List<String> values) {
            if (values.size() == 1) {
                return andReceiverAccountEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " in",
                    values, "receiverAccount");

                return this;
            }
        }

        public Criteria andReceiverAccountNotIn(List<String> values) {
            if (values.size() == 1) {
                return andReceiverAccountNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                    " not in", values, "receiverAccount");

                return this;
            }
        }

        public Criteria andReceiverAccountIn(String[] values) {
            if (values.length == 1) {
                return andReceiverAccountEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " in",
                    Arrays.asList(values), "receiverAccount");

                return this;
            }
        }

        public Criteria andReceiverAccountNotIn(String[] values) {
            if (values.length == 1) {
                return andReceiverAccountNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                    " not in", Arrays.asList(values), "receiverAccount");

                return this;
            }
        }

        public Criteria andReceiverAccountIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andReceiverAccountBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount + " between",
                value1, value2, "receiverAccount");

            return this;
        }

        public Criteria andReceiverAccountNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.ReceiverAccount +
                " not between", value1, value2, "receiverAccount");

            return this;
        }

        public Criteria andSysMessageTitleIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " is null");

            return this;
        }

        public Criteria andSysMessageTitleIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                " is not null");

            return this;
        }

        public Criteria andSysMessageTitleIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                " is not null AND " + ISysMessageReadStatusDAO.SysMessageTitle +
                " <> ''");

            return this;
        }

        public Criteria andSysMessageTitleIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageTitle +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageTitle +
                " = '')");

            return this;
        }

        public Criteria andSysMessageTitleEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " = ",
                value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageTitle);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageTitleEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " <>",
                value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageTitle +
                " <>", value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageTitle);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageTitleNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " >",
                value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageTitle);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageTitleGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " >=",
                value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageTitle);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageTitleGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " <",
                value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageTitle);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageTitleLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " <=",
                value, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageTitle);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageTitleLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " like",
                buffer.toString(), "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                " not like", buffer.toString(), "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageTitleEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " in",
                    values, "sysMessageTitle");

                return this;
            }
        }

        public Criteria andSysMessageTitleNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageTitleNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                    " not in", values, "sysMessageTitle");

                return this;
            }
        }

        public Criteria andSysMessageTitleIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageTitleEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " in",
                    Arrays.asList(values), "sysMessageTitle");

                return this;
            }
        }

        public Criteria andSysMessageTitleNotIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageTitleNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                    " not in", Arrays.asList(values), "sysMessageTitle");

                return this;
            }
        }

        public Criteria andSysMessageTitleIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageTitleBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle + " between",
                value1, value2, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessageTitleNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageTitle +
                " not between", value1, value2, "sysMessageTitle");

            return this;
        }

        public Criteria andSysMessagePriorityIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " is null");

            return this;
        }

        public Criteria andSysMessagePriorityIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " is not null");

            return this;
        }

        public Criteria andSysMessagePriorityIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessagePriority + " <> ''");

            return this;
        }

        public Criteria andSysMessagePriorityIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessagePriority +
                " is null OR " + ISysMessageReadStatusDAO.SysMessagePriority +
                " = '')");

            return this;
        }

        public Criteria andSysMessagePriorityEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " = ",
                value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessagePriority);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessagePriorityEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " <>",
                value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " is null OR " + ISysMessageReadStatusDAO.SysMessagePriority +
                " <>", value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessagePriority);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessagePriorityNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " >",
                value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessagePriority);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessagePriorityGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " >=",
                value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessagePriority);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessagePriorityGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " <",
                value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessagePriority);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessagePriorityLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " <=",
                value, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessagePriority);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessagePriorityLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " like",
                buffer.toString(), "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " not like", buffer.toString(), "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessagePriorityEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                    " in", values, "sysMessagePriority");

                return this;
            }
        }

        public Criteria andSysMessagePriorityNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessagePriorityNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                    " not in", values, "sysMessagePriority");

                return this;
            }
        }

        public Criteria andSysMessagePriorityIn(String[] values) {
            if (values.length == 1) {
                return andSysMessagePriorityEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                    " in", Arrays.asList(values), "sysMessagePriority");

                return this;
            }
        }

        public Criteria andSysMessagePriorityNotIn(String[] values) {
            if (values.length == 1) {
                return andSysMessagePriorityNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                    " not in", Arrays.asList(values), "sysMessagePriority");

                return this;
            }
        }

        public Criteria andSysMessagePriorityIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessagePriorityBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " between", value1, value2, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessagePriorityNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessagePriority +
                " not between", value1, value2, "sysMessagePriority");

            return this;
        }

        public Criteria andSysMessageSendTimeIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime +
                " is null");

            return this;
        }

        public Criteria andSysMessageSendTimeIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime +
                " is not null");

            return this;
        }

        public Criteria andSysMessageSendTimeIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessageSendTime + " <> ''");

            return this;
        }

        public Criteria andSysMessageSendTimeIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageSendTime +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageSendTime +
                " = '')");

            return this;
        }

        public Criteria andSysMessageSendTimeEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " = ", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSendTime);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSendTimeEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeNotEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " <>", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeNotEqualToOrIsNull(
            java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageSendTime +
                " <>", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSendTime);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSendTimeNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeGreaterThan(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " >", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSendTime);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSendTimeGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeGreaterThanOrEqualTo(
            java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " >=", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSendTime);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSendTimeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeLessThan(java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " <", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSendTime);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSendTimeLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeLessThanOrEqualTo(
            java.util.Date value) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " <=", value, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSendTime);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSendTimeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andSysMessageSendTimeEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                    " in", values, "sysMessageSendTime");

                return this;
            }
        }

        public Criteria andSysMessageSendTimeNotIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andSysMessageSendTimeNotEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                    " not in", values, "sysMessageSendTime");

                return this;
            }
        }

        public Criteria andSysMessageSendTimeIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andSysMessageSendTimeEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                    " in", Arrays.asList(values), "sysMessageSendTime");

                return this;
            }
        }

        public Criteria andSysMessageSendTimeNotIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andSysMessageSendTimeNotEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                    " not in", Arrays.asList(values), "sysMessageSendTime");

                return this;
            }
        }

        public Criteria andSysMessageSendTimeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSendTime +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSendTimeBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " between", value1, value2, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageSendTimeNotBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(ISysMessageReadStatusDAO.SysMessageSendTime +
                " not between", value1, value2, "sysMessageSendTime");

            return this;
        }

        public Criteria andSysMessageStatusIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " is null");

            return this;
        }

        public Criteria andSysMessageStatusIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " is not null");

            return this;
        }

        public Criteria andSysMessageStatusIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessageStatus + " <> ''");

            return this;
        }

        public Criteria andSysMessageStatusIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageStatus +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageStatus +
                " = '')");

            return this;
        }

        public Criteria andSysMessageStatusEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " = ",
                value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageStatus);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " <>",
                value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageStatus +
                " <>", value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageStatus);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageStatusNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " >",
                value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageStatus);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageStatusGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " >=",
                value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageStatus);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " <",
                value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageStatus);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageStatusLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " <=",
                value, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageStatus);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageStatusLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " like",
                buffer.toString(), "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " not like", buffer.toString(), "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " in",
                    values, "sysMessageStatus");

                return this;
            }
        }

        public Criteria andSysMessageStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                    " not in", values, "sysMessageStatus");

                return this;
            }
        }

        public Criteria andSysMessageStatusIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " in",
                    Arrays.asList(values), "sysMessageStatus");

                return this;
            }
        }

        public Criteria andSysMessageStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                    " not in", Arrays.asList(values), "sysMessageStatus");

                return this;
            }
        }

        public Criteria andSysMessageStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageStatusBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " between", value1, value2, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageStatusNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageStatus +
                " not between", value1, value2, "sysMessageStatus");

            return this;
        }

        public Criteria andSysMessageContentIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " is null");

            return this;
        }

        public Criteria andSysMessageContentIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " is not null");

            return this;
        }

        public Criteria andSysMessageContentIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessageContent + " <> ''");

            return this;
        }

        public Criteria andSysMessageContentIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageContent +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageContent +
                " = '')");

            return this;
        }

        public Criteria andSysMessageContentEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " = ",
                value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageContent);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageContentEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " <>",
                value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageContent +
                " <>", value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageContent);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageContentNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " >",
                value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageContent);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageContentGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentGreaterThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " >=",
                value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageContent);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageContentGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " <",
                value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageContent);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageContentLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " <=",
                value, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageContent);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageContentLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " like",
                buffer.toString(), "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " not like", buffer.toString(), "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageContentEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                    " in", values, "sysMessageContent");

                return this;
            }
        }

        public Criteria andSysMessageContentNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageContentNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                    " not in", values, "sysMessageContent");

                return this;
            }
        }

        public Criteria andSysMessageContentIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageContentEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                    " in", Arrays.asList(values), "sysMessageContent");

                return this;
            }
        }

        public Criteria andSysMessageContentNotIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageContentNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                    " not in", Arrays.asList(values), "sysMessageContent");

                return this;
            }
        }

        public Criteria andSysMessageContentIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageContentBetween(String value1, String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " between", value1, value2, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageContentNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageContent +
                " not between", value1, value2, "sysMessageContent");

            return this;
        }

        public Criteria andSysMessageSenderNameIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " is null");

            return this;
        }

        public Criteria andSysMessageSenderNameIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " is not null");

            return this;
        }

        public Criteria andSysMessageSenderNameIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessageSenderName + " <> ''");

            return this;
        }

        public Criteria andSysMessageSenderNameIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageSenderName +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageSenderName +
                " = '')");

            return this;
        }

        public Criteria andSysMessageSenderNameEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " = ",
                value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderNameEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " <>",
                value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageSenderName +
                " <>", value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderNameNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " >",
                value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderNameGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " >=",
                value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " <",
                value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderNameLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameLessThanOrEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName + " <=",
                value, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " like", buffer.toString(), "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " not like", buffer.toString(), "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageSenderNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                    " in", values, "sysMessageSenderName");

                return this;
            }
        }

        public Criteria andSysMessageSenderNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageSenderNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                    " not in", values, "sysMessageSenderName");

                return this;
            }
        }

        public Criteria andSysMessageSenderNameIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageSenderNameEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                    " in", Arrays.asList(values), "sysMessageSenderName");

                return this;
            }
        }

        public Criteria andSysMessageSenderNameNotIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageSenderNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                    " not in", Arrays.asList(values), "sysMessageSenderName");

                return this;
            }
        }

        public Criteria andSysMessageSenderNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderNameBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " between", value1, value2, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderNameNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderName +
                " not between", value1, value2, "sysMessageSenderName");

            return this;
        }

        public Criteria andSysMessageSenderAccountIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " is null");

            return this;
        }

        public Criteria andSysMessageSenderAccountIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " is not null");

            return this;
        }

        public Criteria andSysMessageSenderAccountIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessageSenderAccount + " <> ''");

            return this;
        }

        public Criteria andSysMessageSenderAccountIsEmpty() {
            addCriterion("(" +
                ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " is null OR " +
                ISysMessageReadStatusDAO.SysMessageSenderAccount + " = '')");

            return this;
        }

        public Criteria andSysMessageSenderAccountEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " = ", value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderAccount);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderAccountEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountNotEqualTo(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " <>", value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountNotEqualToOrIsNull(
            String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " is null OR " +
                ISysMessageReadStatusDAO.SysMessageSenderAccount + " <>",
                value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderAccount);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderAccountNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountGreaterThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " >", value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderAccount);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderAccountGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountGreaterThanOrEqualTo(
            String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " >=", value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderAccount);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderAccountGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountLessThan(String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " <", value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderAccount);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderAccountLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountLessThanOrEqualTo(
            String value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " <=", value, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderAccount);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderAccountLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " like", buffer.toString(), "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " not like", buffer.toString(), "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageSenderAccountEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                    " in", values, "sysMessageSenderAccount");

                return this;
            }
        }

        public Criteria andSysMessageSenderAccountNotIn(List<String> values) {
            if (values.size() == 1) {
                return andSysMessageSenderAccountNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                    " not in", values, "sysMessageSenderAccount");

                return this;
            }
        }

        public Criteria andSysMessageSenderAccountIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageSenderAccountEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                    " in", Arrays.asList(values), "sysMessageSenderAccount");

                return this;
            }
        }

        public Criteria andSysMessageSenderAccountNotIn(String[] values) {
            if (values.length == 1) {
                return andSysMessageSenderAccountNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                    " not in", Arrays.asList(values), "sysMessageSenderAccount");

                return this;
            }
        }

        public Criteria andSysMessageSenderAccountIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderAccountBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " between", value1, value2, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderAccountNotBetween(String value1,
            String value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderAccount +
                " not between", value1, value2, "sysMessageSenderAccount");

            return this;
        }

        public Criteria andSysMessageSenderIdIsNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " is null");

            return this;
        }

        public Criteria andSysMessageSenderIdIsNotNull() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " is not null");

            return this;
        }

        public Criteria andSysMessageSenderIdIsNotEmpty() {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " is not null AND " +
                ISysMessageReadStatusDAO.SysMessageSenderId + " <> ''");

            return this;
        }

        public Criteria andSysMessageSenderIdIsEmpty() {
            addCriterion("(" + ISysMessageReadStatusDAO.SysMessageSenderId +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageSenderId +
                " = '')");

            return this;
        }

        public Criteria andSysMessageSenderIdEqualTo(long value) {
            return andSysMessageSenderIdEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " = ",
                value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderIdEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdNotEqualTo(long value) {
            return andSysMessageSenderIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " <>",
                value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdNotEqualToOrIsNull(long value) {
            return andSysMessageSenderIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdNotEqualToOrIsNull(
            java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " is null OR " + ISysMessageReadStatusDAO.SysMessageSenderId +
                " <>", value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderIdNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdGreaterThan(long value) {
            return andSysMessageSenderIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " >",
                value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderIdGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdGreaterThanOrEqualTo(long value) {
            return andSysMessageSenderIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdGreaterThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " >=",
                value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdLessThan(long value) {
            return andSysMessageSenderIdLessThan(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdLessThan(java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " <",
                value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderIdLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdLessThanOrEqualTo(long value) {
            return andSysMessageSenderIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andSysMessageSenderIdLessThanOrEqualTo(
            java.lang.Long value) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " <=",
                value, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysMessageReadStatusDAO.SysMessageSenderId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysMessageSenderIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdIn(long[] values) {
            if (values.length == 1) {
                return andSysMessageSenderIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                    " in", values, "sysMessageSenderId");

                return this;
            }
        }

        public Criteria andSysMessageSenderIdNotIn(long[] values) {
            if (values.length == 1) {
                return andSysMessageSenderIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                    " not in", values, "sysMessageSenderId");

                return this;
            }
        }

        public Criteria andSysMessageSenderIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andSysMessageSenderIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                    " in", values, "sysMessageSenderId");

                return this;
            }
        }

        public Criteria andSysMessageSenderIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andSysMessageSenderIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                    " not in", values, "sysMessageSenderId");

                return this;
            }
        }

        public Criteria andSysMessageSenderIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andSysMessageSenderIdEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                    " in", Arrays.asList(values), "sysMessageSenderId");

                return this;
            }
        }

        public Criteria andSysMessageSenderIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andSysMessageSenderIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                    " not in", Arrays.asList(values), "sysMessageSenderId");

                return this;
            }
        }

        public Criteria andSysMessageSenderIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysMessageSenderIdBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " between", value1, value2, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " between", value1, value2, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdNotBetween(long value1, long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " not between", value1, value2, "sysMessageSenderId");

            return this;
        }

        public Criteria andSysMessageSenderIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysMessageReadStatusDAO.SysMessageSenderId +
                " not between", value1, value2, "sysMessageSenderId");

            return this;
        }
    }
}
